UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rUUH6qKRkw2lgxrRUW8vzfkSm6f2hGgen/qdIQtTZsE='
WHERE
key_id = '9e99f97a2aaeda19b78ae66bf3ecf959bf48735542982d0c4b866ada96ff5d76'
AND (
token = 'rUUH6qKRkw2lgxrRUW8vzfkSm6f2hGgen/qdIQtTZsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)