UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6We9nS0DWHPuq66WWIJGpwBZoBCM0cipu7YRjssUGwE='
WHERE
key_id = 'a49e312ffdd27defd882bdebcebcd7a894e3e5cf03561401a4f4b3035413337c'
AND (
token = '6We9nS0DWHPuq66WWIJGpwBZoBCM0cipu7YRjssUGwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)