UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zotwNdJXdEK79uuqiTYeT7wQy1B+eNH/I1hXz1JXUC4='
WHERE
key_id = 'c9b5ea89f98f1158f68e900862945b587c58e294e7274bd08651e85c3c8080fc'
AND (
token = 'zotwNdJXdEK79uuqiTYeT7wQy1B+eNH/I1hXz1JXUC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)