UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XISAvYGh23p76M0WXQIYiufkLrGHPAlvrtAWs9R1M4w='
WHERE
key_id = '711f1fdfac5f7117d115ad48fd3f9131f021d63cc1a197d28760825485aaaa92'
AND (
token = 'XISAvYGh23p76M0WXQIYiufkLrGHPAlvrtAWs9R1M4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)