UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HjCt30/CMQXPxOlfJhkI9SRmdV+rPWCGGVqG/+Dmgig='
WHERE
key_id = 'e9f6a0a0269d884ad0af0ea90a9fafe6c71a4829a8710f48a1b7341802174c26'
AND (
token = 'HjCt30/CMQXPxOlfJhkI9SRmdV+rPWCGGVqG/+Dmgig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)