UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mg3FcHXOWYk4N9q7jxDF0wo92NNKtSmONaN5vBaFhhs='
WHERE
key_id = '89d1c22998dec1b91ca2ae6ab473d01ea18fc475e4f039c60caf14533cf2cc81'
AND (
token = 'mg3FcHXOWYk4N9q7jxDF0wo92NNKtSmONaN5vBaFhhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)