UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9ExirJQ0gXZ+zdA5W8jlX2tIX9MqyzkYqnPT/etaYVg=' 
WHERE 
  key_id = 'c559dcd118b1b5619b7f50c6f6f100cb05a24c5ef04fbcd6914ed4b22576201c' 
  AND (
    token = '9ExirJQ0gXZ+zdA5W8jlX2tIX9MqyzkYqnPT/etaYVg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040