UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCYImEcwWUjFb7jR6Ur0gGG+LyaK4/jHPHjiH8exxGM='
WHERE
key_id = '0bcceb2101f2712207863e5b841947f750fce3730398fdc69d8de891fbc26588'
AND (
token = 'xCYImEcwWUjFb7jR6Ur0gGG+LyaK4/jHPHjiH8exxGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)