UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8OUY36qOKi+iXlNWoebXIFT9kytKgm81KIdW+x7CI4='
WHERE
key_id = '96d063e6fecae33f01fc8ef60bb268455b4ba41965926249c95847bf97296863'
AND (
token = 'q8OUY36qOKi+iXlNWoebXIFT9kytKgm81KIdW+x7CI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)