SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '76394e6a29ffdd0a42112a7a23fba16ab6554499555744c91837fde9d256083d' 
  AND token = 'vm4VaBuzyBRnOj717qbsvokZE8jaTWYSu/Myaa7CeQo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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