UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kB5eq7kdc7dLJKeY2rhCBPPNQyeFxT1+9mlnAzLtdw4='
WHERE
key_id = 'a0cd7ddde151f699ce931e942c2764c58da4a58b7247a4286bb84ab09911d121'
AND (
token = 'kB5eq7kdc7dLJKeY2rhCBPPNQyeFxT1+9mlnAzLtdw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)