UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RO18MXImfg2Q65BDY7ROB1FeYOLy+eJjxHtbJsvBo18='
WHERE
key_id = 'b7cc308ef51e3a42c4dd20757828a95b63ceba081b87e9be480e00cf86c442e8'
AND (
token = 'RO18MXImfg2Q65BDY7ROB1FeYOLy+eJjxHtbJsvBo18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)