UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hpx1s02JOUKMGh0v8vLSixbFvIk+guxN3kLsNrpavz8='
WHERE
key_id = '1f55d3bd1559869fd64ee39c72534a0c0870962035794d7e0c89ad75aaf56f01'
AND (
token = 'Hpx1s02JOUKMGh0v8vLSixbFvIk+guxN3kLsNrpavz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)