UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NS/9zgi6FBV3ImVmVJny7JznDVXCF5YgwtA0xqNtN6g='
WHERE
key_id = 'fd5dc6a2e874835044805c03d1e8e1095ade4c3c3519b66a63b82205a2935647'
AND (
token = 'NS/9zgi6FBV3ImVmVJny7JznDVXCF5YgwtA0xqNtN6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)