UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fCE4PXRwxL7p2OclPULhPZycjIzHcnJQUGPWjSrr/3M='
WHERE
key_id = '9a38c2aa6a56802a9e6ed52124eefa947faf3b30e6002b45d8018b59c414269a'
AND (
token = 'fCE4PXRwxL7p2OclPULhPZycjIzHcnJQUGPWjSrr/3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)