UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jRdcK1v1WGCBiP7VruH7wzJNx3NfSQ1wmeeNI3SDQUw='
WHERE
key_id = '9edace8d20a66448f2e8eac8f0876880e75172031f9aad010d763c503b4237f7'
AND (
token = 'jRdcK1v1WGCBiP7VruH7wzJNx3NfSQ1wmeeNI3SDQUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)