UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fKzSV0ZkNPRdS2woESBZWnkw9QDCTUSyakZrAuI/aNI=' 
WHERE 
  key_id = '693be011bb1402b37e67d4addbd0db8d97df8eb375b90b81978ce3145bde93c5' 
  AND (
    token = 'fKzSV0ZkNPRdS2woESBZWnkw9QDCTUSyakZrAuI/aNI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029