SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'bd8c7137a2930cb83a0124da0e56e90a3a02d652a59fb68bd428e5f11654204a' 
  AND token = 'V86//zT7E1ZRkEXhee9da1SATfQXTZdiRGzaqX4ShNA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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