SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '177d0bd247cea074b6121c0fcc8e7954f0c1ab7b34d3bc05f4fc5bca60e5b9aa' 
  AND token = 'bdmBIJBH4zcFMxUnpFKh/lGNOpoP8VHSjEvBglLjID0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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