SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2f075b5b7d39ce0d41e76612c3945368e013b599f198ab781598a4ac04c5940e' 
  AND token = 'cZ3Yt0FaX6bZ6LSendiTHHXmtczNiy3UPI1FolE4tfQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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