SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5f43c058c93c37b3877387f3a67d0767e970ff1f793c5f0d4f90b828ada5631f' 
  AND token = 'vbpku/4e6SwD8ZN14qPVqM06BTc2CjiZUxt9Ez9BaIk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}