UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2mdMBDT9HKWZmWPYDnCO/bjmhLM+axZxPN75fDrHM64='
WHERE
key_id = 'de4b29ad97bc226ceadf72e9ec58b5b72178cb6b733ec01fb05d483ddb090d72'
AND (
token = '2mdMBDT9HKWZmWPYDnCO/bjmhLM+axZxPN75fDrHM64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)