UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lGswJ402Sog9/oiHgW/RDJL8cse3nOeci7pE5wQRgHY='
WHERE
key_id = 'b7b5a5b8422da5ba7f7ddcdaa67ed61dd6d47851a016ee7625a85e0e0adc2d4e'
AND (
token = 'lGswJ402Sog9/oiHgW/RDJL8cse3nOeci7pE5wQRgHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)