SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2cfc60823291861cc838a8a05525891ad6816e59537d9980fb746e23c0a6e1bb' 
  AND token = 'sYuxrF+aJcK05zK87mJ2oagtiWaqe3j+FbfOSVRp99s=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

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