UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pEoi0DVrjl9y0G4LRy2zL8S2M3LF0LA4YzvmjJKgMw4='
WHERE
key_id = 'c88770d140f3f0634cf5137d112ba6100dd125002c01ae7e4824ba32de7600d9'
AND (
token = 'pEoi0DVrjl9y0G4LRy2zL8S2M3LF0LA4YzvmjJKgMw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)