UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '97gN0hXcP1dJqkJEDNA7qQZBKdY5bbeBrFBkvnP7mYM='
WHERE
key_id = '3da15d5e270c2f9936cd8745545a055680a9362a6c9a7f27af61975d288355e3'
AND (
token = '97gN0hXcP1dJqkJEDNA7qQZBKdY5bbeBrFBkvnP7mYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)