UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DRlsGY4jBlhBSCLe6YgBeYoA01Y/xHs3VF6muFA8llc='
WHERE
key_id = 'e0942c909575c53ba58bf57934a37a7f4f098d16a340cc7140efe3a5be47cc39'
AND (
token = 'DRlsGY4jBlhBSCLe6YgBeYoA01Y/xHs3VF6muFA8llc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)