SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9b2cdad58d31997e3fe093dd9bae231706f4672f91da5b4c15b3fac917453266' 
  AND token = 'CJ3+Q00dq8B6yxOY8vLiXih95ySZjHGiAR63JHNjqe4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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