UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '147gqrBxawgOf2g5klgGp3LqHLFbIFl1RfQvxIPbG0M='
WHERE
key_id = 'cac321164c778f6057ba27f41d889c4be1559cf5437ed0d574e8e89696533fcf'
AND (
token = '147gqrBxawgOf2g5klgGp3LqHLFbIFl1RfQvxIPbG0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)