UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmkEibw3Ea8FTL12duzvSn7rf2Yi93m/VMRuFmimsSE='
WHERE
key_id = 'b7eaeefaa53e01b33b9bd96281b2b8bb2082f2c9aee8a98d228be3ca74b6d78e'
AND (
token = 'QmkEibw3Ea8FTL12duzvSn7rf2Yi93m/VMRuFmimsSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)