UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYeAS64f2NvR+zwNcrW+1hiGMjBSCqDKz6uYIP2wwEw='
WHERE
key_id = '867e711e8e04fad605d7b7cf4aaaae580342c5bc194dffd973d9f69a6404ae6d'
AND (
token = 'nYeAS64f2NvR+zwNcrW+1hiGMjBSCqDKz6uYIP2wwEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)