UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QGKigbeSEQIrhZ0sHU+2qrYfTmRjuQtZzXVkmC10QkY='
WHERE
key_id = '4e52f92a7ba0d8e64718015350652c99391707e3f8befd85b3face6630f5b667'
AND (
token = 'QGKigbeSEQIrhZ0sHU+2qrYfTmRjuQtZzXVkmC10QkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)