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