SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ae71a16e9ea125a2175c3e86f67b3c66632e11fdec99f59fecd1d0ed64ec1261' 
  AND token = '599KCqGn/xGfKZ/q9y88lkaKCQWCLio10tcKkbt4SPo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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