UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gnv79BhNmkeO3ype6UIaR2xg6agNTXiljx2C8kiDCDc='
WHERE
key_id = '046fa5f1e605ab23323177bb96ca1a882ac778a1dd170899dfe481fa2feabc7c'
AND (
token = 'Gnv79BhNmkeO3ype6UIaR2xg6agNTXiljx2C8kiDCDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)