UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Dgq4TXe2k9WWENHvAVeVq5n2BQY39kh00mlz9h3ka+s=' 
WHERE 
  key_id = 'd41e3c3ecce3f0b4d0e492232b7655ce299abec2cdd0f02fa5e44e5b30ece1fa' 
  AND (
    token = 'Dgq4TXe2k9WWENHvAVeVq5n2BQY39kh00mlz9h3ka+s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00050