UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f7BSzfK03JffSagau2aRX23khGVYXAZw27lSoP3BvqM='
WHERE
key_id = 'da8f85b359a06eebd8a6680ce39fad5aaa5d1969fdcb9b9e990525384ad29cbc'
AND (
token = 'f7BSzfK03JffSagau2aRX23khGVYXAZw27lSoP3BvqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)