UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9sI9yXf5yted4LAG0QN56kmBUqD4oh70kFrCn/idrc='
WHERE
key_id = 'cec7d23753a47ba182af4b8b6d8e20c31836f61854f4712ae5c19cd117922562'
AND (
token = 'm9sI9yXf5yted4LAG0QN56kmBUqD4oh70kFrCn/idrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)