UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8C5E3/chQ703e9hoZd5bbCmf823iAh0bU0h0gddtzA='
WHERE
key_id = 'bc5ad0daa7e26fa495e89d76b6cc01806cdd130f55c60d1657962981f7e3a97c'
AND (
token = 'z8C5E3/chQ703e9hoZd5bbCmf823iAh0bU0h0gddtzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)