UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qQDqdr0LNOErbOM8dwstuvxbw+zpfJxRFw3/xyOwiY='
WHERE
key_id = 'c86b00fa78af830fb04a5331b9d422847c10486f553a1c61c195c6f935412de7'
AND (
token = '0qQDqdr0LNOErbOM8dwstuvxbw+zpfJxRFw3/xyOwiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)