UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYrRb6uwy4hqnILMl2TtWuU59btj8hQE+ans5gAXuUY='
WHERE
key_id = 'a8a1bbed9c3803819b1e409cac37252e44f3ce9bec512b8a2ca163e8a986e636'
AND (
token = 'oYrRb6uwy4hqnILMl2TtWuU59btj8hQE+ans5gAXuUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)