UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zrYnIUvjM/ZSAvbnRaUhY7klRvmnptoXVU9jGZ6Ns0='
WHERE
key_id = 'b4ad688aa05ed15fccf6529e477f71d75ce48b3b9624aeb24eacc44073e3e423'
AND (
token = '0zrYnIUvjM/ZSAvbnRaUhY7klRvmnptoXVU9jGZ6Ns0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)