UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj7lJNZw+/n7VTui1mHAcZ2zTR4Y0GrLA3RONcQO+5M='
WHERE
key_id = 'fab786cf5cdf8484b2cc607a6a28b9566a5871b58c58058110be4d90d43b0fd3'
AND (
token = 'zj7lJNZw+/n7VTui1mHAcZ2zTR4Y0GrLA3RONcQO+5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)